﻿CREATE TABLE [title].[Title] (
    [TitleID]          INT          IDENTITY (1, 1) NOT NULL,
    [TitleTypeID]      INT          NULL,
    [ApplicationDate]  DATETIME     NULL,
    [TitleSequence]    VARCHAR (50) NULL,
    [OriginationState] VARCHAR (2)  NULL,
    [CreatedBy]        VARCHAR (50) NULL,
    [CreatedDate]      DATETIME     NULL,
    [UpdatedBy]        VARCHAR (50) NULL,
    [UpdatedDate]      DATETIME     NULL,
    [EndDate]          DATETIME     NULL,
    CONSTRAINT [PK_Title] PRIMARY KEY CLUSTERED ([TitleID] ASC),
    CONSTRAINT [FK_Title_TitleType] FOREIGN KEY ([TitleTypeID]) REFERENCES [title].[TitleType] ([TitleTypeID])
);

